//add fcounty for Missouri
// fips codes accessed here: https://www.nrcs.usda.gov/wps/portal/nrcs/detail/national/home/?cid=nrcs143_013697

gen fcounty=.
replace fcounty=1 if county=="ADAIR" & state=="Missouri"
replace fcounty=3 if county=="ANDREW" & state=="Missouri"
replace fcounty=5 if county=="ATCHISON" & state=="Missouri"
replace fcounty=7 if county=="AUDRAIN" & state=="Missouri"
replace fcounty=9 if county=="BARRY" & state=="Missouri"
replace fcounty=11 if county=="BARTON" & state=="Missouri"
replace fcounty=13 if county=="BATES" & state=="Missouri"
replace fcounty=15 if county=="BENTON" & state=="Missouri"
replace fcounty=17 if county=="BOLLINGER" & state=="Missouri"
replace fcounty=19 if county=="BOONE" & state=="Missouri"
replace fcounty=21 if county=="BUCHANAN" & state=="Missouri"
replace fcounty=23 if county=="BUTLER" & state=="Missouri"
replace fcounty=25 if county=="CALDWELL" & state=="Missouri"
replace fcounty=27 if county=="CALLAWAY" & state=="Missouri"
replace fcounty=29 if county=="CAMDEN" & state=="Missouri"
replace fcounty=31 if county=="CAPE GIRARDEAU" & state=="Missouri"
replace fcounty=33 if county=="CARROLL" & state=="Missouri"
replace fcounty=35 if county=="CARTER" & state=="Missouri"
replace fcounty=37 if county=="CASS" & state=="Missouri"
replace fcounty=39 if county=="CEDAR" & state=="Missouri"
replace fcounty=41 if county=="CHARITON" & state=="Missouri"
replace fcounty=43 if county=="CHRISTIAN" & state=="Missouri"
replace fcounty=45 if county=="CLARK" & state=="Missouri"
replace fcounty=47 if county=="CLAY" & state=="Missouri"
replace fcounty=49 if county=="CLINTON" & state=="Missouri"
replace fcounty=51 if county=="COLE" & state=="Missouri"
replace fcounty=53 if county=="COOPER" & state=="Missouri"
replace fcounty=55 if county=="CRAWFORD" & state=="Missouri"
replace fcounty=57 if county=="DADE" & state=="Missouri"
replace fcounty=59 if county=="DALLAS" & state=="Missouri"
replace fcounty=61 if county=="DAVIESS" & state=="Missouri"
replace fcounty=63 if county=="DEKALB" & state=="Missouri"
replace fcounty=65 if county=="DENT" & state=="Missouri"
replace fcounty=67 if county=="DOUGLAS" & state=="Missouri"
replace fcounty=69 if county=="DUNKLIN" & state=="Missouri"
replace fcounty=71 if county=="FRANKLIN" & state=="Missouri"
replace fcounty=73 if county=="GASCONADE" & state=="Missouri"
replace fcounty=75 if county=="GENTRY" & state=="Missouri"
replace fcounty=77 if county=="GREENE" & state=="Missouri"
replace fcounty=79 if county=="GRUNDY" & state=="Missouri"
replace fcounty=81 if county=="HARRISON" & state=="Missouri"
replace fcounty=83 if county=="HENRY" & state=="Missouri"
replace fcounty=85 if county=="HICKORY" & state=="Missouri"
replace fcounty=87 if county=="HOLT" & state=="Missouri"
replace fcounty=89 if county=="HOWARD" & state=="Missouri"
replace fcounty=91 if county=="HOWELL" & state=="Missouri"
replace fcounty=93 if county=="IRON" & state=="Missouri"
replace fcounty=95 if county=="JACKSON" & state=="Missouri"
replace fcounty=97 if county=="JASPER" & state=="Missouri"
replace fcounty=99 if county=="JEFFERSON" & state=="Missouri"
replace fcounty=101 if county=="JOHNSON" & state=="Missouri"
replace fcounty=103 if county=="KNOX" & state=="Missouri"
replace fcounty=105 if county=="LACLEDE" & state=="Missouri"
replace fcounty=107 if county=="LAFAYETTE" & state=="Missouri"
replace fcounty=109 if county=="LAWRENCE" & state=="Missouri"
replace fcounty=111 if county=="LEWIS" & state=="Missouri"
replace fcounty=113 if county=="LINCOLN" & state=="Missouri"
replace fcounty=115 if county=="LINN" & state=="Missouri"
replace fcounty=117 if county=="LIVINGSTON" & state=="Missouri"
replace fcounty=119 if county=="MCDONALD" & state=="Missouri"
replace fcounty=121 if county=="MACON" & state=="Missouri"
replace fcounty=123 if county=="MADISON" & state=="Missouri"
replace fcounty=125 if county=="MARIES" & state=="Missouri"
replace fcounty=127 if county=="MARION" & state=="Missouri"
replace fcounty=129 if county=="MERCER" & state=="Missouri"
replace fcounty=131 if county=="MILLER" & state=="Missouri"
replace fcounty=133 if county=="MISSISSIPPI" & state=="Missouri"
replace fcounty=135 if county=="MONITEAU" & state=="Missouri"
replace fcounty=137 if county=="MONROE" & state=="Missouri"
replace fcounty=139 if county=="MONTGOMERY" & state=="Missouri"
replace fcounty=141 if county=="MORGAN" & state=="Missouri"
replace fcounty=143 if county=="NEW MADRID" & state=="Missouri"
replace fcounty=145 if county=="NEWTON" & state=="Missouri"
replace fcounty=147 if county=="NODAWAY" & state=="Missouri"
replace fcounty=149 if county=="OREGON" & state=="Missouri"
replace fcounty=151 if county=="OSAGE" & state=="Missouri"
replace fcounty=153 if county=="OZARK" & state=="Missouri"
replace fcounty=155 if county=="PEMISCOT" & state=="Missouri"
replace fcounty=157 if county=="PERRY" & state=="Missouri"
replace fcounty=159 if county=="PETTIS" & state=="Missouri"
replace fcounty=161 if county=="PHELPS" & state=="Missouri"
replace fcounty=163 if county=="PIKE" & state=="Missouri"
replace fcounty=165 if county=="PLATTE" & state=="Missouri"
replace fcounty=167 if county=="POLK" & state=="Missouri"
replace fcounty=169 if county=="PULASKI" & state=="Missouri"
replace fcounty=171 if county=="PUTNAM" & state=="Missouri"
replace fcounty=173 if county=="RALLS" & state=="Missouri"
replace fcounty=175 if county=="RANDOLPH" & state=="Missouri"
replace fcounty=177 if county=="RAY" & state=="Missouri"
replace fcounty=179 if county=="REYNOLDS" & state=="Missouri"
replace fcounty=181 if county=="RIPLEY" & state=="Missouri"
replace fcounty=183 if county=="ST CHARLES" & state=="Missouri"
replace fcounty=185 if county=="ST CLAIR" & state=="Missouri"
replace fcounty=186 if county=="STE GENEVIEVE" & state=="Missouri"
replace fcounty=187 if county=="ST FRANCOIS" & state=="Missouri"
replace fcounty=189 if county=="ST LOUIS COUNTY" & state=="Missouri"
replace fcounty=195 if county=="SALINE" & state=="Missouri"
replace fcounty=197 if county=="SCHUYLER" & state=="Missouri"
replace fcounty=199 if county=="SCOTLAND" & state=="Missouri"
replace fcounty=201 if county=="SCOTT" & state=="Missouri"
replace fcounty=203 if county=="SHANNON" & state=="Missouri"
replace fcounty=205 if county=="SHELBY" & state=="Missouri"
replace fcounty=207 if county=="STODDARD" & state=="Missouri"
replace fcounty=209 if county=="STONE" & state=="Missouri"
replace fcounty=211 if county=="SULLIVAN" & state=="Missouri"
replace fcounty=213 if county=="TANEY" & state=="Missouri"
replace fcounty=215 if county=="TEXAS" & state=="Missouri"
replace fcounty=217 if county=="VERNON" & state=="Missouri"
replace fcounty=219 if county=="WARREN" & state=="Missouri"
replace fcounty=221 if county=="WASHINGTON" & state=="Missouri"
replace fcounty=223 if county=="WAYNE" & state=="Missouri"
replace fcounty=225 if county=="WEBSTER" & state=="Missouri"
replace fcounty=227 if county=="WORTH" & state=="Missouri"
replace fcounty=229 if county=="WRIGHT" & state=="Missouri"
replace fcounty=510 if county=="ST LOUIS CITY" & state=="Missouri"
replace fcounty=95 if county=="KANSAS CITY" & state=="Missouri"

